package com.lottery.dao.pc28.statisticsDao;

import com.lottery.entity.PlaywayMoney;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 玩法金额统计表接口
 */
public interface PlaywayMoneyDao {

	/**
	 * 插入一条数据
	 */
	void insertPlaywayMoney(PlaywayMoney playwayMoney);

	/**
	 * 统计分组查询得到值
	 * 
	 * @return
	 */
	List<PlaywayMoney> getPlaywayMoneyLimit(@Param(value = "expect") String expect);

	/**
	 * 
	 * 获取亏损的金额
	 * 
	 * @return
	 */
	double getBettingmoney(PlaywayMoney playwayMoney);

	/**
	 * 获取中奖的金额
	 * 
	 * @return
	 */
	double getWinningamount(PlaywayMoney playwayMoney);

	/**
	 * 获取最近5期的期号
	 * 
	 * @return
	 */
	List<PlaywayMoney> selectPlaywayMoneyExpect();

	/**
	 * 根据期号和玩法id得到对象
	 * 
	 * @return
	 */
	PlaywayMoney getPlaywayMoney(PlaywayMoney playwayMoney);

}
